package com.tuozixuan.easyexcel;

import java.math.BigDecimal;
import java.util.Date;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;

@HeadRowHeight(value = 18)
@ContentRowHeight(value = 18)
//@ColumnWidth(value = 18)
@ColumnWidth
public class User {
	
	@ExcelProperty(value = "客戶編號", order = 1)
	private Long id;
	
	@ExcelProperty(value = "姓名", order = 2)
	private String name;
	
	@ExcelProperty(value = "月薪", order = 3)
	@ExcelIgnore
	private BigDecimal salary;

	@ExcelProperty(value = "年齡", order = 4)
	private Integer age;
	
	@ExcelProperty(value = "分值", order = 5)
	private Double score;
	
	@ExcelProperty(value = "創建時間", order = 6)
	@DateTimeFormat("dd-MM-yyyy HH:mm:ss")
	private Date createDate;

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public BigDecimal getSalary() {
		return salary;
	}

	public void setSalary(BigDecimal salary) {
		this.salary = salary;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	public Double getScore() {
		return score;
	}

	public void setScore(Double score) {
		this.score = score;
	}

	public Date getCreateDate() {
		return createDate;
	}

	public void setCreateDate(Date createDate) {
		this.createDate = createDate;
	}
	
}
